You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*,orders.cusnum AS d_cusnum from
LEFT JOIN orders ON .ref = orders.ref
where .' at line 1
Shell | $ | |
---|---|---|
BLASICRURA GOODALLII |
25.00 | |
ZONARIA ROBERTSI |
8.00 | |
CONUS SUGIMOTONIS |
20.00 | |
COLUMBELLA FUSCATA |
4.00 | |
LYRIA VICDANI |
15.00 | |
BABELOMUREX WORMALDI |
80.00 | |
TURBO UNDULATUS |
6.00 | |
NERITA SCABRICOSTA |
4.00 | |
BABELOMUREX WORMALDI |
40.00 | |
CONUS TEXTILE ARCHIEPISCOPUS |
25.00 | |
ANGARIA POPPEI |
8.00 | |
STROMBINA GIBBERULA |
4.00 | |
MONETARIA MONETA |
8.00 | |
SINUM PERSPECTIVUM |
6.00 | |
PYRAMIDELLA VENTRICOSA |
4.00 | |
CONUS SURATENSIS |
25.00 | |
CONUS TESSULATUS |
6.00 | |
ERRONEA PULCHELLA NOVAEBRITTANIAE |
60.00 | |
COSTELLARIA POTIERI |
25.00 | |
LYRIA SOLANGEAE |
160.00 | |
ERRONEA PULCHELLA PULCHELLA |
8.00 | |
OVINOTIS OVINA |
4.00 | |
Total: | 545.00 |